package com.fumihiko.modules.jxxm.dao;

import com.baomidou.mybatisplus.core.conditions.query.QueryWrapper;
import com.baomidou.mybatisplus.core.toolkit.Constants;
import com.fumihiko.modules.jxxm.entity.RetiredEmployeesEntity;
import com.baomidou.mybatisplus.core.mapper.BaseMapper;
import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Param;

import java.util.List;
import java.util.Map;

/**
 *
 *
 * @author hanwenpeng
 * @email devilzwy@gmail.com
 * @date 2021-11-30 18:29:50
 */
@Mapper
public interface RetiredEmployeesDao extends BaseMapper<RetiredEmployeesEntity> {

    List<RetiredEmployeesEntity> getName(String query);


    void removeByState(Long[] ids);

    List<RetiredEmployeesEntity> getTypeNum(String area);

    List<RetiredEmployeesEntity> getZzmmNum(String area);

    List<RetiredEmployeesEntity> getNationNum(String area);

    List<RetiredEmployeesEntity> getSexNum(String area);

    List<RetiredEmployeesEntity> getTxqsfNum(String area);

    List<RetiredEmployeesEntity> getTxqzwNum(String area);

    List<RetiredEmployeesEntity> getEmployeeNum(String area);

    List<RetiredEmployeesEntity> getYjsjdNum(String area);

    List<RetiredEmployeesEntity> getYbdNum(String area);

    List<RetiredEmployeesEntity> getStreetNum(String area);

    List<RetiredEmployeesEntity> getAreaNum(String area);


    List<String> queryRepeatList();

    List<RetiredEmployeesEntity> listDeathExcel(@Param(Constants.WRAPPER) QueryWrapper<RetiredEmployeesEntity> queryWrapper);

    List<RetiredEmployeesEntity> getStreetByContry(String contrys);

    void recoveryById(Long[] ids);

    List<RetiredEmployeesEntity> getAllList();

    List<RetiredEmployeesEntity> getResultList();


    List<RetiredEmployeesEntity> listDeathPensionExcel(@Param(Constants.WRAPPER) QueryWrapper<RetiredEmployeesEntity> queryWrapper);

    List<RetiredEmployeesEntity> listAddPensionExcel(@Param(Constants.WRAPPER) QueryWrapper<RetiredEmployeesEntity> queryWrapper);

    List<RetiredEmployeesEntity> getData();

    RetiredEmployeesEntity getDataById(Long id);

    List<RetiredEmployeesEntity> getListAddPensionAll();
}
